UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XBW9yHy5KehoEi08bCDTwgXrZz4z/9N/zlSWQeuLPM8='
WHERE
key_id = '23c8ce62eca819383fcc012aea393a60d66df612d17b2af93a13540cb42e0b93'
AND (
token = 'XBW9yHy5KehoEi08bCDTwgXrZz4z/9N/zlSWQeuLPM8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)