UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BFIvR9w6jd965WxsU8x30m0Oqc9KAiIoGB84Hb0mhxI='
WHERE
key_id = 'a862d8e7348c27f8122aea6144858933aeef1c5ebe25d4e905ac3e7fccd8ca7a'
AND (
token = 'BFIvR9w6jd965WxsU8x30m0Oqc9KAiIoGB84Hb0mhxI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)