UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gb/G0dDwdEUU0lfksltwmC6jtLVI5I3sDZIjyags+aA='
WHERE
key_id = '4fac1a6130840a2ebf4a0f2b1d239b6f8005bc15172640ddf90723a2b7aca067'
AND (
token = 'gb/G0dDwdEUU0lfksltwmC6jtLVI5I3sDZIjyags+aA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)