UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4guHaJdVTdCmAiHlNKwaLJFlvclsD28QFGNUS95oGHg='
WHERE
key_id = '151ddf29b64db4b3a004fd3018c2c88e3ec6d5260bb5b67957e3873f1ebef8ef'
AND (
token = '4guHaJdVTdCmAiHlNKwaLJFlvclsD28QFGNUS95oGHg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)