UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YqPHatJPDHYH6HVY0iTbJftpN2yl/pNYAoIq7xiWAPk='
WHERE
key_id = '8e0a6b43f50fa1223c4097791a603930854f828e83292183ee2fe40d330a29d5'
AND (
token = 'YqPHatJPDHYH6HVY0iTbJftpN2yl/pNYAoIq7xiWAPk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)