UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9vLLal0jmfaP2kQdgq13FdDYrS7qzxUZSiSy1Iuz6v4='
WHERE
key_id = 'c12256113aa4d3899aa588b52c48b948d2f0e4a2ad4d6170d492161798ed060f'
AND (
token = '9vLLal0jmfaP2kQdgq13FdDYrS7qzxUZSiSy1Iuz6v4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)