UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'AiOu9tuzxN/YSRL2jzlqHzkHDQq/mZUcyIsyNjlhlgE=' 
WHERE 
  key_id = '9393bd699475e26d3b97578797fb7d95efe1b2531e142fe5a1b838dc48315863' 
  AND (
    token = 'AiOu9tuzxN/YSRL2jzlqHzkHDQq/mZUcyIsyNjlhlgE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024