UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'etNXIhl2y0m/eTlC1hPavFdu5hsKSoFcst3JHB0g1vs='
WHERE
key_id = 'bc7d23a367491385b3c8b9f9895ec30d88e5e0112965c8dfe3a8e36e2f2c1252'
AND (
token = 'etNXIhl2y0m/eTlC1hPavFdu5hsKSoFcst3JHB0g1vs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)