UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'PHUWCIPco6MfYgf69pfM7xiYhRTIc2flN2aOxK5F/Zg=' 
WHERE 
  key_id = '1de1c7f9c9cd18cf0aaa55a56cce0f06e710c83b07401b538b49dcd5ae11bc49' 
  AND (
    token = 'PHUWCIPco6MfYgf69pfM7xiYhRTIc2flN2aOxK5F/Zg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043