UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y7eGjgbzkjF9AgkgxrJeMXd3z/Vt/ptHHL0HbUbIgFM='
WHERE
key_id = 'b9bd840f7e03af3b7eb48d84dfa3817f4d137387458642cbf19bf0852cca3e6a'
AND (
token = 'Y7eGjgbzkjF9AgkgxrJeMXd3z/Vt/ptHHL0HbUbIgFM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)