UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '24IdlhWIIJtEmoyND/jXW13s3cEJ4bjPGHFGRUpvjJM='
WHERE
key_id = '9b6b492357a0859a8025294272cd07cb265d6eaa8edc02e0a8bd047b4c4b2f62'
AND (
token = '24IdlhWIIJtEmoyND/jXW13s3cEJ4bjPGHFGRUpvjJM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)