UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p9ybURjYQRseZ6VA9Lsw6cYiXYXR3nimQjcfjO1nWj0='
WHERE
key_id = '2c5254097eef30ce8c2546699bdd9117457b7abcd1abb47badd5b9d6b9f93886'
AND (
token = 'p9ybURjYQRseZ6VA9Lsw6cYiXYXR3nimQjcfjO1nWj0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)