UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '77VRNY97rI6Jd+dmrEkqYDyXq517nzF4aR5xqLftLwg='
WHERE
key_id = '6397993099ec97d8d59b08a34b66b0877a334ec717bbe78211fc1ae09423bd07'
AND (
token = '77VRNY97rI6Jd+dmrEkqYDyXq517nzF4aR5xqLftLwg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)