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