UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X+/NQ5wQW/PGAkEMtRV83JXQf5xSjCwlbZ+MNb93z34='
WHERE
key_id = 'e3ce3d5c9ec1b7ddc72fea526af7dbeea4120a5abd77c8901caa10c74c244551'
AND (
token = 'X+/NQ5wQW/PGAkEMtRV83JXQf5xSjCwlbZ+MNb93z34='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)