UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6uo3knB+I0a4Jvg69bOk00gCjQnwThpRgCLoaWRCvnE='
WHERE
key_id = 'd9f0757828cde9a072deea49582daf648377c62d73110e4fd7e69bc7b9fb64bd'
AND (
token = '6uo3knB+I0a4Jvg69bOk00gCjQnwThpRgCLoaWRCvnE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)