UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6GhK8e82Gb0mihh1ZVwAjZlW4Lt3nMa8hjaGrk4HIgY='
WHERE
key_id = 'fc4b69d2d02696fb597bab7958711b5a0c8230f0944a4b74f77acfea6aa02cf7'
AND (
token = '6GhK8e82Gb0mihh1ZVwAjZlW4Lt3nMa8hjaGrk4HIgY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)