UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '00H9bu/6poijYgCMJzr/8mic5rsIxwey5sAgdIq4QWM='
WHERE
key_id = '9db2ac199bfad8213660bfa693735f92b3ad80dbbbba451a0a2f073a0e5efa2c'
AND (
token = '00H9bu/6poijYgCMJzr/8mic5rsIxwey5sAgdIq4QWM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)