UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'lR7h1y0E62lX/Lb+cXqAaNskxNExHO0EeT8+9YCOnCI=' 
WHERE 
  key_id = '88784ae8cdac1c516233cb67ce2ae253f68a5fb7d291b9079d8e2db4824bc8b4' 
  AND (
    token = 'lR7h1y0E62lX/Lb+cXqAaNskxNExHO0EeT8+9YCOnCI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031