UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oHokFIgcVBGnN/fadaW1so/x+BGoe6pOLodGuaK/l5U='
WHERE
key_id = 'b1b9a30a815260ebe6193835792e210cf6d8316b51fe737bb50e20b1fd99bce1'
AND (
token = 'oHokFIgcVBGnN/fadaW1so/x+BGoe6pOLodGuaK/l5U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)