UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SJXWHzNWWjBS5io2XR3Jy18y08IbzZCvF46bYjvoaI4='
WHERE
key_id = '96391567c126f35205cc0f879a55ceb11ba6d99b1832b5645294daf5c42f734c'
AND (
token = 'SJXWHzNWWjBS5io2XR3Jy18y08IbzZCvF46bYjvoaI4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)