UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vpR7gESWWwvhtuAqkXLLxXfFkTP7vz1m6nhC3HQmKLo='
WHERE
key_id = 'cce042dc8cf06e8c119bd8c05b632d6c2edc63d88c5d7c56147337a79db18d3b'
AND (
token = 'vpR7gESWWwvhtuAqkXLLxXfFkTP7vz1m6nhC3HQmKLo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)