UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r16zAHGMFL21Y6ouVvKO3l5c4ltvZGLrrUL+IHCNQSo='
WHERE
key_id = 'f764fed41f73e46f69cc11a13a03654c523c9b397167154dced322e3b02c79f8'
AND (
token = 'r16zAHGMFL21Y6ouVvKO3l5c4ltvZGLrrUL+IHCNQSo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)