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