UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'xENU0NJRIAS/yQPYo+XBesG3KRK4q0bYMyxWR6YGZ1g=' 
WHERE 
  key_id = 'f2a818c70d1d79050a5d60366b6cfacf6dd6b7b34a735d78e72571473dc294d2' 
  AND (
    token = 'xENU0NJRIAS/yQPYo+XBesG3KRK4q0bYMyxWR6YGZ1g=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022