UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nK8JYmwOrnbOpbp+y07wH8bKCdLTzrBU4LAm97EeY00='
WHERE
key_id = '0c7c4967ca39e9237e10c9297b17a422975592af811036ff195e78895344a984'
AND (
token = 'nK8JYmwOrnbOpbp+y07wH8bKCdLTzrBU4LAm97EeY00='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)