UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '08gfngh13J7hMsRelMUU9/scwlG3Q0QyYZYObi/oyaI='
WHERE
key_id = 'a083bc9b69f80053caf569f0ed59f5f546a6abe4e95d46ffac6a1899de503d18'
AND (
token = '08gfngh13J7hMsRelMUU9/scwlG3Q0QyYZYObi/oyaI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)