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