UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VdyGzW6I/sfjAPXEpWZVO81mWUusweg0ZQsvnATj5Jg='
WHERE
key_id = 'fa1e54ea299a4fcbd1bfa9c4190ef1783f068a6ca9b0b1d8788cf9242b608037'
AND (
token = 'VdyGzW6I/sfjAPXEpWZVO81mWUusweg0ZQsvnATj5Jg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)