UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+0uUA/tEJU9VpAsSMUhRJAfX/h60OiyxVSlHxnF6kAA='
WHERE
key_id = '82b5fb3923ba64a725ae997c7bf1099e4343266a7b5453fadee53b3f470571df'
AND (
token = '+0uUA/tEJU9VpAsSMUhRJAfX/h60OiyxVSlHxnF6kAA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)