UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '7akIxtA8lRYqNB4m9W4mxw9yNnxYLQr8wWyz7WQUI2c=' 
WHERE 
  key_id = 'ae929389402054897bf85e43211c7e5c6435f36591901532378d143f8f5773d7' 
  AND (
    token = '7akIxtA8lRYqNB4m9W4mxw9yNnxYLQr8wWyz7WQUI2c=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023