UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BA7eQ7rZ6s9cNeFUZJZEq08Y6h48apErAdUfvp30Gks='
WHERE
key_id = '5ac670c047d6a22c255a695130953ae28d0941dd5db1930552dbff141ad2c3be'
AND (
token = 'BA7eQ7rZ6s9cNeFUZJZEq08Y6h48apErAdUfvp30Gks='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)