UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZU11f4U7+ghTFtQFI5Eif+LrzLsh9/eYoKCHe818NsA='
WHERE
key_id = '3bbb7d44f9eaed92d39b1ec756b46159c5355cebe4a2bc8e2208e514e1af09d8'
AND (
token = 'ZU11f4U7+ghTFtQFI5Eif+LrzLsh9/eYoKCHe818NsA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)