UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NpxAWqmUKjUEZwubUefBbXNd1DCS1p2wwZeL/grtWiE='
WHERE
key_id = '7bc38d9e71d02f5786169b26aae42a9cb31c3fd1a8a8e07281b39ab44a531203'
AND (
token = 'NpxAWqmUKjUEZwubUefBbXNd1DCS1p2wwZeL/grtWiE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)