UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AwBtvxt0FjDyKcVit9BklF71fa1J9biMiUGrRl7yruI='
WHERE
key_id = '55e28f6f2dad3fd05b2d0b23ce647c28f28735e61f63f3723af8b3cb27491ed5'
AND (
token = 'AwBtvxt0FjDyKcVit9BklF71fa1J9biMiUGrRl7yruI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)