UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l1vLxqqh1Qxeg45U5OyuYtZEgS6PFU37eAUD6P1R800='
WHERE
key_id = '290aef3a0d58fbbde3291af570b9bf64c55bcec576d4b5ea72a102957b95c8a8'
AND (
token = 'l1vLxqqh1Qxeg45U5OyuYtZEgS6PFU37eAUD6P1R800='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)