UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'huJRYwkbty1EwOhB3z1kNzIRoq65wuvsxjpznx8OCLE='
WHERE
key_id = 'e5c03a76b2efaa3c19a960f25ad3012fa9991fbe8559823bf1895a2671a9315e'
AND (
token = 'huJRYwkbty1EwOhB3z1kNzIRoq65wuvsxjpznx8OCLE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)