UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'WHBD4aGb422n1Uv1dw4ZZJRXMfN9X+MD6DGlBl7JTQk=' 
WHERE 
  key_id = 'c6e0c046bc48b869323cbd4b80244e76879a801e104a85d3ab68b0ee2687356f' 
  AND (
    token = 'WHBD4aGb422n1Uv1dw4ZZJRXMfN9X+MD6DGlBl7JTQk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020