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