UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2RKIYjuGTd5mmF0yKxaQwxurkysJwM89n7wmPl91gI8='
WHERE
key_id = '579f3dae2ee244c871127aaf627607ab11e3ddd3713829f09cc8880bb098187f'
AND (
token = '2RKIYjuGTd5mmF0yKxaQwxurkysJwM89n7wmPl91gI8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)