UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '38wsXKlgbINo+5y4YOCtK+m+438G6KnO73AjCZinC4w='
WHERE
key_id = 'f839bc27264fbd49782d670783408c36fc5a274faf71041aa4edfa21e230c2b0'
AND (
token = '38wsXKlgbINo+5y4YOCtK+m+438G6KnO73AjCZinC4w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)