UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZOjpoYkU+dsHWNAfbv32Rq52LA4OMfjF2paQ5vocwno='
WHERE
key_id = '6a73dee7925978dfa8ba8692f536e58cf8bca4efcba8cc7609f42c9a0807859b'
AND (
token = 'ZOjpoYkU+dsHWNAfbv32Rq52LA4OMfjF2paQ5vocwno='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)