UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zNF0fxJy5fhsAsb/4562kavNyyt+tyNxNs6W94JmuFk='
WHERE
key_id = '5b4c4d37a93a5ca977b2febba8fdeb10a3c57eca5403dcfe2398ec87204fda77'
AND (
token = 'zNF0fxJy5fhsAsb/4562kavNyyt+tyNxNs6W94JmuFk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)