UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zAJDQdS4Ohe/ydtefFEWWWEQPuaG4Zkoa+TnVLm8Ko0='
WHERE
key_id = '8b87f595d4b15207ef038183c50d30084d60bddcfc5dacef1cf4761862b7f391'
AND (
token = 'zAJDQdS4Ohe/ydtefFEWWWEQPuaG4Zkoa+TnVLm8Ko0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)