UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8InAfDpOz1M0OouUGZVDRK4mVtEsf0x1MpTD7KmN0N8='
WHERE
key_id = '56464dd45e78b9745c48294c5455a2bd468fefa967f1084a912b1f3d74a9c474'
AND (
token = '8InAfDpOz1M0OouUGZVDRK4mVtEsf0x1MpTD7KmN0N8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)